<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en"><title id="hh141670">pg_resourcetype</title><body><p>The <codeph>pg_resourcetype</codeph> system catalog table contains information about the extended
      attributes that can be assigned to Greenplum Database resource queues. Each row
      details an attribute and inherent qualities such as its default setting, whether it is
      required, and the value to disable it (when allowed).</p><p>This table is populated only on the master. This table is defined
in the <codeph>pg_global</codeph> tablespace, meaning it is globally
shared across all databases in the system.</p><table id="hh141982"><title>pg_catalog.pg_resourcetype</title><tgroup cols="4"><colspec colnum="1" colname="col1" colwidth="131pt"/><colspec colnum="2" colname="col2" colwidth="86pt"/><colspec colnum="3" colname="col3" colwidth="85pt"/><colspec colnum="4" colname="col4" colwidth="147pt"/><thead><row><entry colname="col1">column</entry><entry colname="col2">type</entry><entry colname="col3">references</entry><entry colname="col4">description</entry></row></thead><tbody><row><entry colname="col1"><codeph>restypid </codeph></entry><entry colname="col2">smallint</entry><entry colname="col3"/><entry colname="col4">The resource type ID.</entry></row><row><entry colname="col1"><codeph>resname</codeph></entry><entry colname="col2">name</entry><entry colname="col3"/><entry colname="col4">The name of the resource type.</entry></row><row><entry colname="col1"><codeph>resrequired</codeph></entry><entry colname="col2">boolean</entry><entry colname="col3"/><entry colname="col4">Whether the resource type is required for a
valid resource queue.</entry></row><row><entry colname="col1"><codeph>reshasdefault</codeph></entry><entry colname="col2">boolean</entry><entry colname="col3"/><entry colname="col4">Whether the resource type has a default value.
When true, the default value is specified in reshasdefaultsetting.
</entry></row><row><entry colname="col1"><codeph>rescandisable</codeph></entry><entry colname="col2">boolean</entry><entry colname="col3"/><entry colname="col4">Whether the type can be removed or disabled.
When true, the default value is specified in resdisabledsetting.
</entry></row><row><entry colname="col1"><codeph>resdefaultsetting</codeph></entry><entry colname="col2">text</entry><entry colname="col3"/><entry colname="col4">Default setting for the resource type, when
applicable. </entry></row><row><entry colname="col1"><codeph>resdisabledsetting</codeph></entry><entry colname="col2">text</entry><entry colname="col3"/><entry colname="col4">The value that disables this resource type (when
allowed). </entry></row></tbody></tgroup></table></body></topic>